IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'CGO_PaymentStatus')
                    AND OBJECTPROPERTY(id, N'IsTable') = 1 ) 
  BEGIN
    DROP TABLE dbo.CGO_PaymentStatus
  END


CREATE TABLE [dbo].[CGO_PaymentStatus]
  (
    [StatusID] [int] NOT NULL IDENTITY(1, 1) ,
    [StatusCode] [nvarchar](100) NOT NULL
  )
ON
  [PRIMARY]
GO
ALTER TABLE [dbo].[CGO_PaymentStatus] ADD CONSTRAINT [PK_CGO_PaymentStatus] PRIMARY KEY CLUSTERED  ([StatusID]) ON [PRIMARY]
GO

INSERT INTO dbo.CGO_PaymentStatus
        ( StatusCode )
VALUES  ( 'WaitingForPay'  -- StatusCode - nvarchar(100)
          )
          
INSERT INTO dbo.CGO_PaymentStatus
        ( StatusCode )
VALUES  ( 'Processing'  -- StatusCode - nvarchar(100)
          )

INSERT INTO dbo.CGO_PaymentStatus
        ( StatusCode )
VALUES  ( 'Completed'  -- StatusCode - nvarchar(100)
          )

INSERT INTO dbo.CGO_PaymentStatus
        ( StatusCode )
VALUES  ( 'Failed'  -- StatusCode - nvarchar(100)
          )

INSERT INTO dbo.CGO_PaymentStatus
        ( StatusCode )
VALUES  ( 'Refund'  -- StatusCode - nvarchar(100)
          )